select distinct a.id,a.tgl_lahir,a.nama, b.jenis, a.nama_kk, a.sex_id from patients a LEFT JOIN typepatients b ON b.id=a.typepatient_id where a.no_kartu="0002346254458" and a.id="03703300" limit 1
